
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_board
-- ----------------------------
DROP TABLE IF EXISTS `t_board`;
CREATE TABLE `t_board` (
  `board_id` int(11) NOT NULL AUTO_INCREMENT,
  `board_name` varchar(150) NOT NULL,
  `board_desc` varchar(255) NOT NULL,
  `topic_num` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`board_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_board
-- ----------------------------
BEGIN;
INSERT INTO `t_board` VALUES (1, 'XXX', 'XXXX', 3);
INSERT INTO `t_board` VALUES (6, 'XXXXX', 'XXXXXXX', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_board_manager
-- ----------------------------
DROP TABLE IF EXISTS `t_board_manager`;
CREATE TABLE `t_board_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `board_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_board_manager
-- ----------------------------
BEGIN;
INSERT INTO `t_board_manager` VALUES (1, 6, 1);
COMMIT;

-- ----------------------------
-- Table structure for t_login_log
-- ----------------------------
DROP TABLE IF EXISTS `t_login_log`;
CREATE TABLE `t_login_log` (
  `login_log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '发表者ID',
  `ip` varchar(30) NOT NULL COMMENT '登录IP',
  `login_datatime` datetime NOT NULL COMMENT '登录时间',
  PRIMARY KEY (`login_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_login_log
-- ----------------------------
BEGIN;
INSERT INTO `t_login_log` VALUES (1, 1, '0:0:0:0:0:0:0:1', '2017-03-06 18:16:05');
INSERT INTO `t_login_log` VALUES (2, 1, '172.31.15.148', '2017-03-06 18:21:09');
INSERT INTO `t_login_log` VALUES (3, 1, '0:0:0:0:0:0:0:1', '2017-03-07 10:27:32');
INSERT INTO `t_login_log` VALUES (4, 1, '127.0.0.1', '2017-03-07 14:54:44');
INSERT INTO `t_login_log` VALUES (5, 1, '0:0:0:0:0:0:0:1', '2017-03-07 15:19:53');
INSERT INTO `t_login_log` VALUES (6, 2, '0:0:0:0:0:0:0:1', '2017-03-07 15:30:54');
INSERT INTO `t_login_log` VALUES (7, 2, '0:0:0:0:0:0:0:1', '2017-03-07 15:37:51');
INSERT INTO `t_login_log` VALUES (8, 1, '0:0:0:0:0:0:0:1', '2017-03-07 16:06:50');
INSERT INTO `t_login_log` VALUES (9, 1, '0:0:0:0:0:0:0:1', '2017-03-07 16:09:35');
INSERT INTO `t_login_log` VALUES (10, 2, '127.0.0.1', '2017-03-07 16:20:16');
INSERT INTO `t_login_log` VALUES (11, 2, '127.0.0.1', '2017-03-07 16:23:12');
INSERT INTO `t_login_log` VALUES (12, 2, '127.0.0.1', '2017-03-07 16:26:31');
INSERT INTO `t_login_log` VALUES (13, 2, '127.0.0.1', '2017-03-07 16:27:52');
INSERT INTO `t_login_log` VALUES (14, 1, '127.0.0.1', '2017-03-07 16:28:09');
INSERT INTO `t_login_log` VALUES (15, 1, '127.0.0.1', '2017-03-07 16:28:22');
INSERT INTO `t_login_log` VALUES (16, 1, '127.0.0.1', '2017-03-07 16:38:02');
INSERT INTO `t_login_log` VALUES (17, 1, '127.0.0.1', '2017-03-07 16:52:22');
INSERT INTO `t_login_log` VALUES (18, 1, '127.0.0.1', '2017-03-07 17:15:04');
INSERT INTO `t_login_log` VALUES (19, 1, '127.0.0.1', '2017-03-07 17:32:54');
INSERT INTO `t_login_log` VALUES (20, 1, '127.0.0.1', '2017-03-07 17:33:16');
INSERT INTO `t_login_log` VALUES (21, 1, '127.0.0.1', '2017-03-07 17:35:01');
INSERT INTO `t_login_log` VALUES (22, 3, '127.0.0.1', '2017-03-07 17:57:21');
INSERT INTO `t_login_log` VALUES (23, 1, '127.0.0.1', '2017-03-07 17:59:39');
INSERT INTO `t_login_log` VALUES (24, 1, '127.0.0.1', '2017-03-08 12:41:04');
INSERT INTO `t_login_log` VALUES (25, 1, '0:0:0:0:0:0:0:1', '2017-03-08 12:49:44');
INSERT INTO `t_login_log` VALUES (26, 1, '0:0:0:0:0:0:0:1', '2017-03-08 12:58:40');
INSERT INTO `t_login_log` VALUES (27, 1, '0:0:0:0:0:0:0:1', '2017-03-08 14:16:52');
INSERT INTO `t_login_log` VALUES (28, 1, '127.0.0.1', '2017-03-08 14:21:43');
INSERT INTO `t_login_log` VALUES (29, 1, '0:0:0:0:0:0:0:1', '2017-03-08 14:27:55');
INSERT INTO `t_login_log` VALUES (30, 1, '0:0:0:0:0:0:0:1', '2017-03-08 14:36:52');
INSERT INTO `t_login_log` VALUES (31, 1, '0:0:0:0:0:0:0:1', '2017-03-08 14:38:08');
INSERT INTO `t_login_log` VALUES (32, 1, '127.0.0.1', '2017-03-08 14:55:01');
INSERT INTO `t_login_log` VALUES (33, 3, '127.0.0.1', '2017-03-08 15:02:13');
INSERT INTO `t_login_log` VALUES (34, 1, '127.0.0.1', '2017-03-08 15:38:22');
INSERT INTO `t_login_log` VALUES (35, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:43:51');
INSERT INTO `t_login_log` VALUES (36, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:45:08');
INSERT INTO `t_login_log` VALUES (37, 1, '127.0.0.1', '2017-03-08 15:44:23');
INSERT INTO `t_login_log` VALUES (38, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:45:27');
INSERT INTO `t_login_log` VALUES (39, 4, '127.0.0.1', '2017-03-08 15:46:03');
INSERT INTO `t_login_log` VALUES (40, 1, '127.0.0.1', '2017-03-08 15:47:05');
INSERT INTO `t_login_log` VALUES (41, 1, '127.0.0.1', '2017-03-08 15:47:13');
INSERT INTO `t_login_log` VALUES (42, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:54:57');
INSERT INTO `t_login_log` VALUES (43, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:56:35');
INSERT INTO `t_login_log` VALUES (44, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:56:58');
INSERT INTO `t_login_log` VALUES (45, 1, '0:0:0:0:0:0:0:1', '2017-03-08 15:59:26');
INSERT INTO `t_login_log` VALUES (46, 1, '0:0:0:0:0:0:0:1', '2017-03-08 16:11:53');
INSERT INTO `t_login_log` VALUES (47, 1, '0:0:0:0:0:0:0:1', '2017-03-08 16:36:46');
INSERT INTO `t_login_log` VALUES (48, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:17:53');
INSERT INTO `t_login_log` VALUES (49, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:30:29');
INSERT INTO `t_login_log` VALUES (50, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:37:14');
INSERT INTO `t_login_log` VALUES (51, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:39:20');
INSERT INTO `t_login_log` VALUES (52, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:39:43');
INSERT INTO `t_login_log` VALUES (53, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:44:38');
INSERT INTO `t_login_log` VALUES (54, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:52:58');
INSERT INTO `t_login_log` VALUES (55, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:55:14');
INSERT INTO `t_login_log` VALUES (56, 1, '0:0:0:0:0:0:0:1', '2017-03-08 17:57:35');
INSERT INTO `t_login_log` VALUES (57, 1, '0:0:0:0:0:0:0:1', '2017-03-08 18:02:12');
INSERT INTO `t_login_log` VALUES (58, 1, '127.0.0.1', '2017-03-08 18:04:22');
INSERT INTO `t_login_log` VALUES (59, 1, '127.0.0.1', '2017-03-08 18:11:04');
INSERT INTO `t_login_log` VALUES (60, 1, '0:0:0:0:0:0:0:1', '2017-03-09 10:01:59');
INSERT INTO `t_login_log` VALUES (61, 1, '0:0:0:0:0:0:0:1', '2017-03-09 10:02:56');
INSERT INTO `t_login_log` VALUES (62, 1, '0:0:0:0:0:0:0:1', '2017-03-09 10:04:29');
INSERT INTO `t_login_log` VALUES (63, 1, '0:0:0:0:0:0:0:1', '2017-03-09 10:37:07');
INSERT INTO `t_login_log` VALUES (64, 1, '0:0:0:0:0:0:0:1', '2017-03-09 10:39:16');
INSERT INTO `t_login_log` VALUES (65, 3, '127.0.0.1', '2017-03-09 10:41:26');
INSERT INTO `t_login_log` VALUES (66, 3, '127.0.0.1', '2017-03-09 16:16:19');
INSERT INTO `t_login_log` VALUES (67, 3, '127.0.0.1', '2017-03-09 16:29:35');
INSERT INTO `t_login_log` VALUES (68, 3, '127.0.0.1', '2017-03-09 16:32:50');
INSERT INTO `t_login_log` VALUES (69, 3, '127.0.0.1', '2017-03-09 16:36:57');
INSERT INTO `t_login_log` VALUES (70, 3, '127.0.0.1', '2017-03-09 16:38:36');
INSERT INTO `t_login_log` VALUES (71, 1, '0:0:0:0:0:0:0:1', '2017-03-09 16:52:36');
INSERT INTO `t_login_log` VALUES (72, 1, '0:0:0:0:0:0:0:1', '2017-03-09 17:08:10');
INSERT INTO `t_login_log` VALUES (73, 1, '0:0:0:0:0:0:0:1', '2017-03-09 17:09:41');
INSERT INTO `t_login_log` VALUES (74, 1, '0:0:0:0:0:0:0:1', '2017-03-09 17:14:30');
INSERT INTO `t_login_log` VALUES (75, 1, '0:0:0:0:0:0:0:1', '2017-03-09 17:15:15');
INSERT INTO `t_login_log` VALUES (76, 3, '127.0.0.1', '2017-03-09 17:19:10');
INSERT INTO `t_login_log` VALUES (77, 1, '0:0:0:0:0:0:0:1', '2017-03-09 18:38:46');
INSERT INTO `t_login_log` VALUES (78, 1, '0:0:0:0:0:0:0:1', '2017-03-09 18:43:11');
INSERT INTO `t_login_log` VALUES (79, 1, '0:0:0:0:0:0:0:1', '2017-03-09 18:46:38');
INSERT INTO `t_login_log` VALUES (80, 1, '0:0:0:0:0:0:0:1', '2017-03-20 15:33:17');
INSERT INTO `t_login_log` VALUES (81, 1, '0:0:0:0:0:0:0:1', '2017-03-20 15:33:40');
INSERT INTO `t_login_log` VALUES (82, 3, '0:0:0:0:0:0:0:1', '2017-03-20 15:46:33');
INSERT INTO `t_login_log` VALUES (83, 1, '0:0:0:0:0:0:0:1', '2017-03-20 15:48:41');
INSERT INTO `t_login_log` VALUES (84, 1, '127.0.0.1', '2017-03-20 16:40:17');
INSERT INTO `t_login_log` VALUES (85, 1, '127.0.0.1', '2017-03-20 16:45:29');
INSERT INTO `t_login_log` VALUES (86, 1, '127.0.0.1', '2017-03-20 16:47:47');
INSERT INTO `t_login_log` VALUES (87, 1, '127.0.0.1', '2017-03-20 16:50:19');
INSERT INTO `t_login_log` VALUES (88, 1, '127.0.0.1', '2017-03-20 16:53:38');
INSERT INTO `t_login_log` VALUES (89, 1, '127.0.0.1', '2017-03-20 17:16:21');
COMMIT;

-- ----------------------------
-- Table structure for t_post
-- ----------------------------
DROP TABLE IF EXISTS `t_post`;
CREATE TABLE `t_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '帖子ID',
  `board_id` int(11) NOT NULL DEFAULT '0' COMMENT '论坛ID',
  `topic_id` int(11) NOT NULL DEFAULT '0' COMMENT '话题ID，该列建立索引',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '发表者ID',
  `post_type` tinyint(4) NOT NULL DEFAULT '2' COMMENT '帖子类型：1主帖子 2：回复帖子',
  `post_title` varchar(50) NOT NULL COMMENT '帖子标题',
  `post_text` longtext NOT NULL COMMENT '帖子内容',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`post_id`),
  KEY `index_topic_id` (`topic_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_post
-- ----------------------------
BEGIN;
INSERT INTO `t_post` VALUES (1, 1, 1, 3, 1, '秋雨贴子001', '秋雨帖子内容', '2017-03-09 16:38:41');
INSERT INTO `t_post` VALUES (2, 1, 1, 1, 1, '秋雨贴子002', '秋雨帖子内容002', '2017-03-09 17:09:45');
INSERT INTO `t_post` VALUES (3, 1, 1, 1, 2, '秋雨贴子002', '帖子很不错', '2017-03-09 17:16:33');
INSERT INTO `t_post` VALUES (4, 1, 1, 3, 1, '秋雨贴子003', '秋雨帖子内容', '2017-03-09 17:19:44');
INSERT INTO `t_post` VALUES (5, 1, 1, 3, 2, '秋雨贴子003', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:25:38');
INSERT INTO `t_post` VALUES (6, 1, 1, 3, 2, '秋雨贴子003', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:26:00');
INSERT INTO `t_post` VALUES (7, 1, 1, 3, 2, '秋雨贴子003', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:26:14');
INSERT INTO `t_post` VALUES (8, 1, 1, 3, 2, '秋雨贴子003', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:26:25');
INSERT INTO `t_post` VALUES (9, 1, 1, 3, 1, '秋雨帖子内东方的惹人烦秋雨贴子秋雨东方的惹人烦秋雨贴', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:28:38');
INSERT INTO `t_post` VALUES (10, 1, 1, 3, 1, '秋雨帖子内东方的惹人烦秋雨贴子秋雨东方的惹人烦秋雨贴秋雨帖子内东方的惹人烦秋雨', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:29:04');
INSERT INTO `t_post` VALUES (11, 1, 1, 3, 1, '秋雨帖子内东方的惹人烦秋雨贴子秋雨东方的惹人烦秋雨贴秋雨帖子惹人烦秋雨贴秋雨帖子内东方的惹人烦秋雨', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:30:05');
INSERT INTO `t_post` VALUES (12, 1, 1, 3, 1, '秋雨帖子内东方的惹人烦秋雨贴子秋雨东方的惹人烦秋雨贴秋雨帖子惹人烦秋雨贴秋雨帖子内东方的惹人烦秋雨1', '秋雨帖子内东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦秋雨贴子003东方的惹人烦容', '2017-03-09 17:30:09');
COMMIT;

-- ----------------------------
-- Table structure for t_topic
-- ----------------------------
DROP TABLE IF EXISTS `t_topic`;
CREATE TABLE `t_topic` (
  `topic_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '帖子ID',
  `board_id` int(11) NOT NULL COMMENT '所属论坛',
  `topic_title` varchar(100) NOT NULL DEFAULT '' COMMENT '帖子标题，该列建立索引',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '发表用户，该列建立索引',
  `create_time` datetime NOT NULL COMMENT '发表时间',
  `last_post` datetime DEFAULT NULL COMMENT '最后回复时间',
  `topic_views` int(11) NOT NULL DEFAULT '1' COMMENT '浏览数',
  `topic_replies` int(11) NOT NULL DEFAULT '0',
  `digest` int(11) NOT NULL COMMENT '0:不是精华话题 1：是精华话题',
  PRIMARY KEY (`topic_id`),
  KEY `index_topic_title` (`topic_title`) USING HASH,
  KEY `index_user_id` (`user_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_topic
-- ----------------------------
BEGIN;
INSERT INTO `t_topic` VALUES (1, 1, 'qiuyu', 1, '2017-03-08 18:11:33', '2017-03-08 18:11:33', 3, 5, 0);
INSERT INTO `t_topic` VALUES (3, 6, 'dreamyao', 1, '2017-03-09 10:39:27', NULL, 0, 0, 0);
INSERT INTO `t_topic` VALUES (4, 1, '秋雨话题001', 3, '2017-03-09 10:47:59', NULL, 0, 0, 0);
INSERT INTO `t_topic` VALUES (5, 1, '秋雨话题002', 3, '2017-03-09 10:48:22', NULL, 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户名，该列建立索引',
  `password` varchar(30) NOT NULL COMMENT '密码',
  `user_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1:普通用户 2：管理员',
  `locked` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:未锁定 1锁定',
  `credit` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `last_visit` datetime DEFAULT NULL,
  `last_ip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `index_user_name` (`user_name`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (1, 'dreamyao', '123456', 1, 0, 0, '2017-03-20 17:16:21', NULL);
INSERT INTO `t_user` VALUES (2, 'dreamyao001', '123456', 1, 0, 0, '2017-03-07 16:27:52', NULL);
INSERT INTO `t_user` VALUES (3, 'dreamyao002', '123456', 1, 0, 0, '2017-03-20 15:46:33', NULL);
INSERT INTO `t_user` VALUES (4, 'dreamyao003', '123456', 1, 0, 0, '2017-03-08 15:46:03', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
